UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X6EDIyuBK3dcVHudOIEHSB8iOG4Htomogq28fER74QM='
WHERE
key_id = 'ed003b00af1de60c530f6c273e90c8d9cc18259bd766be745a26502cd30c4ffd'
AND (
token = 'X6EDIyuBK3dcVHudOIEHSB8iOG4Htomogq28fER74QM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)