UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lcLXOMijjqzduNUGyI8Bw1L371Wkqb/F+gHNWL38msU='
WHERE
key_id = '2fdc61e7d11f99c6d73aac0037eac0b08c3ba36759bd4171c265fc4564f33a3e'
AND (
token = 'lcLXOMijjqzduNUGyI8Bw1L371Wkqb/F+gHNWL38msU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)