UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PLAaEI+93ye1QPEO5jrqr7D9XMUxxOyAJw1Sg8YpkY0='
WHERE
key_id = 'ebce996def937ad164bcd3fb2168a5740f2bd171e6e253a9f6b0fca81579e72c'
AND (
token = 'PLAaEI+93ye1QPEO5jrqr7D9XMUxxOyAJw1Sg8YpkY0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)