UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3OLi9VR49EXtLi1WVzmhxaFr1+meKMvW/aE9jilaB7M='
WHERE
key_id = '167fadef7dce8e3cfa505f7af0a5a710264ee6df54a3bb467a9c1590c5988cc6'
AND (
token = '3OLi9VR49EXtLi1WVzmhxaFr1+meKMvW/aE9jilaB7M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)