UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KtbK/LSntL0ds9Yc0pqdK1ZxpCRf/Y+4zZs98lwjOhA='
WHERE
key_id = '2bacf47df28414045ec6c47022ec7550012f60be18b66008f34effb4a92a9d99'
AND (
token = 'KtbK/LSntL0ds9Yc0pqdK1ZxpCRf/Y+4zZs98lwjOhA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)