UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JlKLQcXpG/irOYRs1+nzzPmFuAU0L5J4o4CMsfx6ww0='
WHERE
key_id = '38e807c815fce7f175b9ddb156c81a9895781a3af012e6f805fcb2d61b487c17'
AND (
token = 'JlKLQcXpG/irOYRs1+nzzPmFuAU0L5J4o4CMsfx6ww0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)