UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SDg91xfEOK0IVbjt5Lk7mj5FzS7FdBFhzrlKgN7K7Us='
WHERE
key_id = 'a0180c0be8e0483814df303bbfff3bc26b03774980030be85fc56746ebfd3fd2'
AND (
token = 'SDg91xfEOK0IVbjt5Lk7mj5FzS7FdBFhzrlKgN7K7Us='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)