UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N/hpWXfc6MLClw22iqdpJwoM0nibsgItjy8Md0dBHkM='
WHERE
key_id = '523d6358d5592f980c1de5622d661bab4b71eace9ab18403a6f996f4b041d324'
AND (
token = 'N/hpWXfc6MLClw22iqdpJwoM0nibsgItjy8Md0dBHkM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)