UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a1KCJP+ktMN+zcbgjkJ109Wks/Jk4+080//EFKp5+ho='
WHERE
key_id = '37c86d430bbedfc3dfbcd1be2c1ed5061ddf3374b0d30dc1b9838961baa7ec18'
AND (
token = 'a1KCJP+ktMN+zcbgjkJ109Wks/Jk4+080//EFKp5+ho='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)