UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c+NDSegpb872vcIujtxbeXFgwWi2tRuDmh0f9O2Jqx4='
WHERE
key_id = '4f4a5e8e714a9b0add2a328db8fe70857f69dc55550784a523db5e00ba51ae02'
AND (
token = 'c+NDSegpb872vcIujtxbeXFgwWi2tRuDmh0f9O2Jqx4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)