UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5BWkQnpnBeu2TfA6PTpRYu7aSVWw6gzyGI9fvqxxZtk='
WHERE
key_id = '4505ef8a7b76c97dbd2734065134247417f49f6168e7893c7a347a8c02e1793e'
AND (
token = '5BWkQnpnBeu2TfA6PTpRYu7aSVWw6gzyGI9fvqxxZtk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)