UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zDUJIyzaABm2vdvC8VSKGOuymjr1DfYD9xJi5IDnke8='
WHERE
key_id = '04331c200df2ff76d2eae06a7b368584bb2b7239823cda95368b7c05c38ce309'
AND (
token = 'zDUJIyzaABm2vdvC8VSKGOuymjr1DfYD9xJi5IDnke8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)