UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BuPf5kAsWC1dwQJjpUUh0KUzoMOmEi8W93mUqAvTQPI='
WHERE
key_id = '9eacdb86f4d8e6d39a766264c38ad6e059fa7be8b27c3e8c46f24a5df704db1f'
AND (
token = 'BuPf5kAsWC1dwQJjpUUh0KUzoMOmEi8W93mUqAvTQPI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)