UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WAfJVea410BxdEZxSzaDja7vtwXYC/fR6A4eGeVYldw='
WHERE
key_id = 'a58401438f58b4eccc3c6e90977a59a67fc61cfa302c5dbee93b56ebe95560ee'
AND (
token = 'WAfJVea410BxdEZxSzaDja7vtwXYC/fR6A4eGeVYldw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)