UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U7w4493ejxXB32yPao3BrRmOwyU3rxYhlgt9Pvs1Cmg='
WHERE
key_id = '6e78fa0ca4961b176c20b141f53612db11b6b61f5c3f058ecf235c79780318bd'
AND (
token = 'U7w4493ejxXB32yPao3BrRmOwyU3rxYhlgt9Pvs1Cmg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)