UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ljgzkw5kvvF8tIQxtNX4Hy6G6k0qOutG9REGnPekFfA='
WHERE
key_id = 'a843905d95f88a4c06582a5e1d82727cce3030bd62018a6024a1231dac185f01'
AND (
token = 'Ljgzkw5kvvF8tIQxtNX4Hy6G6k0qOutG9REGnPekFfA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)