UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mJjJwoNez6SO8oLm+geQJT8EVnOzrcozV45kRMR/zWc='
WHERE
key_id = 'a575e57d8b10dac0fe51ff008b95f65a4e1a96d4ebadcac664355a5b38fc7878'
AND (
token = 'mJjJwoNez6SO8oLm+geQJT8EVnOzrcozV45kRMR/zWc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)