UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mDI302oDFFif2Ut5RS6sXdp8pvudxd4DIJXf8kkplok='
WHERE
key_id = '0b917bd5d56717ed3d0b182b1e7a8bb05ba6316f79e26935b7c6c39d1e42b67c'
AND (
token = 'mDI302oDFFif2Ut5RS6sXdp8pvudxd4DIJXf8kkplok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)