UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9hnduI8Ut3tJSSEpb40p+ogGE+QXNy7M2OTpYR+eDZE='
WHERE
key_id = '3ba06b5065edbeb3c8124368bfee3567ef11b1a61c55b257429944f4b6da8b24'
AND (
token = '9hnduI8Ut3tJSSEpb40p+ogGE+QXNy7M2OTpYR+eDZE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)