UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pnWx5N8ijYkAOay6ZS9KEAd/SDsW0SHTW1fJVNs9lrA='
WHERE
key_id = '9a016998850154f24df54f76ea2352885132e4522156355ac73520bb40f8ddb6'
AND (
token = 'pnWx5N8ijYkAOay6ZS9KEAd/SDsW0SHTW1fJVNs9lrA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)