UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tGk6OHDhsjb1AzhtriYtr9hPmX2N8j+Rh7nNQSbvx30='
WHERE
key_id = '8192c28643084ab9cf873327fca8a0244b398d8d585047e7f3fe3e49b2857cdc'
AND (
token = 'tGk6OHDhsjb1AzhtriYtr9hPmX2N8j+Rh7nNQSbvx30='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)