UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hRS06lDpWPlD9hxy0UGt2aUzsX7bascVWoo6pJesddA='
WHERE
key_id = '483407fa01f33e27ae514d3a2f329aaa5e009a85b5c28395e0cd4de2d72f4794'
AND (
token = 'hRS06lDpWPlD9hxy0UGt2aUzsX7bascVWoo6pJesddA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)