UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6hlzylR3i0HthxoQ5m4sKQe6E+60QH6hlLERAItEdnA='
WHERE
key_id = '2d7d1ec96831b111bd68feaac35367f19264d9e29928733280ee9bd50d3441d5'
AND (
token = '6hlzylR3i0HthxoQ5m4sKQe6E+60QH6hlLERAItEdnA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)