UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8gxt5HmLVn4/TCweYWZloUCFA5j0rJrcL4ffcJl/ESg='
WHERE
key_id = '1dc1074987195321b95c0b814c177bc4542fcf5ba9410279033ff95743cd18c2'
AND (
token = '8gxt5HmLVn4/TCweYWZloUCFA5j0rJrcL4ffcJl/ESg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)