UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gQX4mKIsDty+u4OWh57NCYeFA2lDV1n20S9wwNKCNMU='
WHERE
key_id = '578e717a1068edfd36c812bca55ab7869562d669e4fa646da10ba92b86a46784'
AND (
token = 'gQX4mKIsDty+u4OWh57NCYeFA2lDV1n20S9wwNKCNMU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)