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