UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3OkARKM4jfdBpDNNXhq8lhS+IgmQs/W1W3NHXK+Lxdk='
WHERE
key_id = 'ac94ca31dbf112c2f57d85360f407dcd2475f37c443376045c738d10d2b05237'
AND (
token = '3OkARKM4jfdBpDNNXhq8lhS+IgmQs/W1W3NHXK+Lxdk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)