UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hx9ZDCji8UQZq/mca2YfjVqL9zIfzBNiaD80JGa0sfo='
WHERE
key_id = '0e581c094934d03f28d50ea7411421050145c72d37adcf8408bf2fca72dca745'
AND (
token = 'hx9ZDCji8UQZq/mca2YfjVqL9zIfzBNiaD80JGa0sfo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)