UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pHWRcUQLp7FT5U56YnEV7FnxML2akKRd8i+z6LNxIzA='
WHERE
key_id = '6a540aee04a28e1b799e7b967496a6ea9eb61ed7b3d1688e2cfec4cfb6af9868'
AND (
token = 'pHWRcUQLp7FT5U56YnEV7FnxML2akKRd8i+z6LNxIzA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)