UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BxfF/BzcVSs+406NtHOQnN1Rtv9Da956xGttG3QUI10='
WHERE
key_id = 'e315a55ca9987c676778139d63962316b9877e816c3dd644b6f366d2006cddf2'
AND (
token = 'BxfF/BzcVSs+406NtHOQnN1Rtv9Da956xGttG3QUI10='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)