UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O0hrXWPcoasmXaJkSwEDx5gpxMbm/BwWBY10tIYCpX8='
WHERE
key_id = 'b1a6d8f827eab88432e6c494c86cf566ea61851265111297d048bfb266a3cca0'
AND (
token = 'O0hrXWPcoasmXaJkSwEDx5gpxMbm/BwWBY10tIYCpX8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)