UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AvdW8JAvch1FjXD6UWGiK0+eUbSKiaSynyWExkSmRrc='
WHERE
key_id = '13a4d0751111bb5c4eabcce2f9bdc991d4d8f100999f9984b24a8403cbaf4e8f'
AND (
token = 'AvdW8JAvch1FjXD6UWGiK0+eUbSKiaSynyWExkSmRrc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)