UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UHv6PRzxjVMYdj5YsAnf6hk/bFbW00ooA6Omnc5/uk0='
WHERE
key_id = 'fd6e64c07a1e4f9fae34bb5c71681eab5d14bd7302e50ec71a985f9f6474750a'
AND (
token = 'UHv6PRzxjVMYdj5YsAnf6hk/bFbW00ooA6Omnc5/uk0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)