UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G8iYCA5sPC75p7lzGpUEEWgPPluJjMchDbrcPk8AYQQ='
WHERE
key_id = 'ddb56ac294702ca30bb8f447dc29dd0d88b0819403da7fedfca192ce2d120583'
AND (
token = 'G8iYCA5sPC75p7lzGpUEEWgPPluJjMchDbrcPk8AYQQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)